ࡱ> ~} ZO\pSusan Richardson Ba==p.8X@"1-Arial1-Arial1-Arial1-Arial1-Arial1-Arial1-Arial1-Arial1-Arial1-Arial1*h6U Calibri Light1,6UCalibri16UCalibri16UCalibri1UCalibri1UCalibri1<UCalibri1>UCalibri1?UCalibri14UCalibri14UCalibri1 UCalibri1 UCalibri1UArial1UCalibri1UCalibri1 UCalibri1UCalibri"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) 0.0000000 0.000000 0.0000"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)                                                                      ff + ) , *     P  P        `            a>    !X*  @* "X* &X*  H* !X)  H)  @)  X)    L) !X  @  H  D  @ "/ ( "+ !X* !X) !X  # "P ) ) "  ) !  !     ||bS'}-}; 00_)}A}1 00_)[$ -}A}2 00_)?[$ -}A}3 00_)23[$ -}-}4 00_)}A}0 a00_)[$ -}A}( 00_)[$ -}A}7 W00_)[$ -}}5 ??v00_)̙[$ -##0.  }}9 ???00_)[$ -???##0.??? ??? ???}}) }00_)[$ -##0.  }A}6 }00_)[$ -}}* 00_)[$ -???##0.??? ??? ???}-}= 00_)}x}800_)[$???## ??? ???}-}/ 00_)}U}< 00_)[$## }A}" 00_)[$}A} 00_)ef[$}A} 00_)L[$}A} 00_)23[$}A}# 00_)[$}A} 00_)ef[$}A} 00_)L[$}A} 00_)23[$}A}$ 00_)[$}A} 00_)ef[$}A} 00_)L[$}A} 00_)23[$}A}% 00_)[$}A} 00_)ef[$}A} 00_)L[$}A} 00_)23[$}A}& 00_)[$}A} 00_)ef[$}A} 00_)L[$}A}  00_)23[$}A}' 00_) [$}A} 00_)ef [$}A} 00_)L [$}A}! 00_)23 [$ 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L˭ % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  L % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23 % 60% - Accent3M( 60% - Accent3 23 % 60% - Accent4M, 60% - Accent4 23f % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23Ў % "Accent1AAccent1 Dr % #Accent2A!Accent2 }1 % $Accent3A%Accent3  % %Accent4A)Accent4  % &Accent5A-Accent5 [ % 'Accent6A1Accent6  pG %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text % 0Good;Good  a%1 Heading 1G Heading 1 DTj%Dr2 Heading 2G Heading 2 DTj%?3 Heading 3G Heading 3 DTj%234 Heading 49 Heading 4 DTj% 5InputuInput ̙ ??v% 6 Linked CellK Linked Cell }% 7NeutralANeutral  W%"Normal 8Noteb Note   9OutputwOutput  ???%????????? ???:$Percent ;Title1Title DTj% <TotalMTotal %DrDr= Warning Text? Warning Text %XTableStyleMedium2PivotStyleLight16`BSheet1jSheet2kSheet35fNf8@ZR3 A@@  ,Compute z-test from 95% confidence intervalsStep 2: Input sectionStep 3: Percent Plus or minusOutput sectionp-value: Calculationspooled standard error Z-statisticThis spreadsheet computes the p-value for a test of the difference between two point estimates, given ther 95% confidence intervals and sample sizes.Note: This spreadsheet implements a standard z-test for the difference in two means. (See Fisher, L.D. and van Belle, G. (1993). Biostatistics, a Methodology for the health Sciences, First Edition. NY: Wiley and Sons. Page 163.)Your local resultState (or comparison) result Local Result State Result6Is your local result different from the state result? eIf this p-value is less than 0.05, then your result is significantly different from the state result.Step 1: Step 4: 7Enter the percent you are comparing in orange cell B12.pEnter the margin of error (the number in parentheses with a , on the right of your percent) in yellow cell D12.7Enter the percent you are comparing in orange cell B11.pEnter the margin of error (the number in parentheses with a , on the right of your percent) in yellow cell D11.HHow to Determine if Your Local Result is Different from the State ResultxUse this test ONLY if there are 30 or more students for the local results and 30 or more students for the state results.Do NOT use this test if one of the percents is either 0% or 100%, as the z-test for proportions is not valid in that circumstance."\/ /13:ccW  PK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭V~&}"!ᇺ_Ν =r!sh ۴T**~ r׮+JOp'M:kүݭjkh [+wc5(_Zw:Mנ_^F֯A)v[_BJ Pl5 cFZԩnΕ(,cuc;P@$=9K !'> BLra)l)oڣh#CZ&beIĐD7 o߼9{og/^=eVe80_~n&_xw_?zоIwOG,:D?DĒ@!vnu6Y7=B>ı0]hq qޜOM#N\{7Ql9=M f-G8S Ǝ=%IJk 9l,k 4I @ʅH~-tx F]n }L-3CS">i}$CތM\[Ht)#,Ky ? v{"%t#LdM!GQ1w}k׺ O!QL×07c]YfGVvi`> X6I?!aW`=@v hT_"BOwxf(_nڼ UΙJpb/N aZG!jxqÕnAr.:M#߉H|nq7\OVlK:RRlkZha$9릫j}W^eu7=M/3\O//٨iG:3hgL(BO}<ь:g#$.Hxω {!J`4T@UK^vVx:lN:E5L+@2_/uR]ӻLf)낀 c3ĖDug`4 }kaQs/\e^Gn~" 8hGOμNO3b/" tMq]{9f//Uncompressed-Data//QcTCKbb``dbaHeeHbHdHf`# 022*W(g*()%d*Z(rWd)[$RtC@2`);TCOM5>>>>>>"dXX??&cU} }  } I}  } }  } }  }  } } $}  @@@:@@@@@X@ @ @ @  @ @@,@ @ x@ ;   K@ I@ @ ^^^^^^^^^^^ ZZZZZZZZZZZ ]]]]]]]]]]] _ __________ ```````````> `aaaaaaaaaa> @??@@ ] ]]]]]> RAABB U [[[[[ @@@@@ V YYYYY  @ A A A @ZZZZZZZZZ C~ O<@ A~ Q @ @ ] ]]]]] C~ O@@ A~ Q? @ U [ [[[[  @@@@@ V Y YYYY  ZZZZZZZZZZZ SDEEEFF \ \\\ F GG*H`!]+? DAA& EFI X XXX FGGFEFIXXXX ZZZZZZZZZZZ TJKKKKKZZZZ K K LLLFM ? 0D \(\?D \(\?@AKZZZZN K K LLL(M^ߥ @ D D DKZZZZ WWWWWWWWWWW X XXXXXXXXXX PPPPPPPPPPP 4, ,,..8NBN`lB B~ ,h ,(  B  P@`?Line 1s]`>@                      7gg@ ZO #k  dMbP?_*+%&?'?(?)?"?? &U>@7ggD ZO l  dMbP?_*+%&?'?(?)?"??&U>@7ggD Oh+'0Tz X`   ,44HYS Tool for Determining Statistical Significance0Healthy Youth Survey Planning Committee (HYSPC)Susan RichardsonMicrosoft Excel@e@?]e@iGy9 <  .''"SystemvH(06.u- . --' -' -' -- -- @ !----- -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$  -- - -$     -- - -$     -- - -$     -- - -$     -- - -$   -- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- -''----- -$01100-- - -$01100-- - -$01100-- - -$01100-- - -$01100-- - -$01100-- - -$01100-- - -$01 1 00-- - -$ 0 1 1 0 0-- - -$ 0 1 1 0 0-- - -$ 0 1 1 0 0-- - -$ 0 1 1 0 0-- - -$ 0 110 0-- - -$01100-- - -$01100-- - -$01100-- - -$01100-- - -$01100-- - -$01100-- - -$01100-- - -$01100-- - -$01100-- - -$01100-- -''----- -$=>>==-- - -$=>>==-- - -$=>>==-- - -$=>>==-- - -$=>>==-- - -$=>>==-- - -$=>>==-- - -$=> > ==-- - -$ = > > = =-- - -$ = > > = =-- - -$ = > > = =-- - -$ = > > = =-- - -$ = >>= =-- - -$=>>==-- - -$=>>==-- - -$=>>==-- - -$=>>==-- - -$=>>==-- - -$=>>==-- - -$=>>==-- - -$=>>==-- - -$=>>==-- - -$=>>==-- -''----- -$OPPOO-- - -$OPPOO-- - -$OPPOO-- - -$OPPOO-- - -$OPPOO-- - -$OPPOO-- - -$OPPOO-- - -$OP P OO-- - -$ O P P O O-- - -$ O P P O O-- - -$ O P P O O-- - -$ O P P O O-- - -$ O PPO O-- - -$OPPOO-- - -$OPPOO-- - -$OPPOO-- - -$OPPOO-- - -$OPPOO-- - -$OPPOO-- - -$OPPOO-- - -$OPPOO-- - -$OPPOO-- - -$OPPOO-- -''----- -$uvvuu-- - -$uvvuu-- - -$uvvuu-- - -$uvvuu-- - -$uvvuu-- - -$uvvuu-- - -$uvvuu-- - -$uv v uu-- - -$ u v v u u-- - -$ u v v u u-- - -$ u v v u u-- - -$ u v v u u-- - -$ u vvu u-- - -$uvvuu-- - -$uvvuu-- - -$uvvuu-- - -$uvvuu-- - -$uvvuu-- - -$uvvuu-- - -$uvvuu-- - -$uvvuu-- - -$uvvuu-- - -$uvvuu-- -''----- -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$ -- - -$ -- - -$ -- - -$ -- - -$ -- - -$  -- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- -''----- -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$ -- - -$ -- - -$ -- - -$ -- - -$ -- - -$  -- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- -''----- -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$ -- - -$ -- - -$ -- - -$ -- - -$ -- - -$  -- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- -''- Arial-  DDD 2 1 2 . 2>2 2 @ 3 2 f 4 2 5 2 6 2 7-- --- @ !----- -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$  -- - -$     -- - -$     -- - -$     -- - -$     -- - -$   -- - -$-- - -$-- - -$-- -''----- -$rrssr-- - -$rrssr-- - -$rrssr-- - -$rrssr-- - -$rrssr-- - -$rrssr-- - -$rrssr-- - -$rrssr-- - -$rr s sr-- - -$r r s s r -- - -$r r s s r -- - -$r r s s r -- - -$r r s s r -- - -$r rss r -- - -$rrssr-- - -$rrssr-- - -$rrssr-- -''----- -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$ -- - -$ -- - -$ -- - -$ -- - -$ -- - -$  -- - -$-- - -$-- - -$-- -''----- -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$-- - -$ -- - -$ -- - -$ -- - -$ -- - -$ -- - -$  -- - -$-- - -$-- - -$-- -''----- -$  -- - -$  -- - -$  -- - -$  -- - -$  -- - -$  -- - -$  -- - -$  -- - -$  -- - -$     -- - -$     -- - -$     -- - -$     -- - -$     -- - -$  -- - -$  -- - -$  -- -''----- -$++,,+-- - -$++,,+-- - -$++,,+-- - -$++,,+-- - -$++,,+-- - -$++,,+-- - -$++,,+-- - -$++,,+-- - -$++ , ,+-- - -$+ + , , + -- - -$+ + , , + -- - -$+ + , , + -- - -$+ + , , + -- - -$+ +,, + -- - -$++,,+-- - -$++,,+-- - -$++,,+-- -''--   DDD 2 CA 2 B 2 C 2 D 2 "E --   @ !-   @ !-&&iA Ff  ( """""""""""""""B"""""""""""""""""""""""""""""""""""&&&--&&-  && & $& &&- $-&&&&&-&&&TNPP '&&TNPP''-   DDD- -' DDD--   @ !7 Arial-   Arial- Arial- Arial------- --'- -  1-s2 HHow to Determine if Your Local Result is Different from the State Result                 ---'--  P-?I2 @,Compute z-test from 95% confidence intervals    ---'--  v-Q2 RThis spreadsheet computes the p-value for a test of the difference between two point estimates, given ther 95% confidence intervals and      2 c sample sizes. -------------'--  -w----"2 Use this test ONLY  - @ !r- -2 f if there are 30 or more students for the local results and 30 or more students for the state results.  ----'--  >-22 .-----------'--  -----2 Do NOT use this  - @ !h- -2 rtest if one of the percents is either 0% or 100%, as the z-test for proportions is not valid in that circumstance.   ----'--  ---'--  --  -- @ !-ss- @ !s-- @ !-- @ !-  - @ ! -,,- @ !,-.- @ !-11.- @ !1->>.- @ !>-PP.- @ !P-vv.- @ !v-.- @ !--.- @ !---.- @ !---'- ---'- --  --- @ !--- @ !-'#A -( ՜.+,0 PXd lt|  Sheet1Sheet2Sheet3  Worksheets  !"#$%&'()*+,-./012345689:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstvwxyz{|Root Entry FWorkbook1mSummaryInformation(7zDocumentSummaryInformation8u